home *** CD-ROM | disk | FTP | other *** search
/ Visual Cafe 3 / Visual Cafe 3.ISO / Vcafe / Sample.bin / CreateCoffees.java < prev    next >
Text File  |  1998-06-30  |  1KB  |  54 lines
  1.  
  2. import java.sql.*;
  3.      
  4. // Create the Coffee Table.
  5. public class CreateCoffees {
  6.  
  7.     public static void main(String args[]) {          
  8.           
  9.       /****************
  10.       DataTable dt = new JDBCAdapter(
  11.             "jdbc:sybase://dbtest:1455/spring",
  12.             "SELECT * FROM test",
  13.             "connect.sybase.SybaseDriver",
  14.             "guest",
  15.             "trustworthy");
  16.       *******************************/
  17.  
  18.         String url = "jdbc:sybase://dbtest:1455/spring";
  19.         Connection con;
  20.         String createString;
  21.         createString = "create table COFFEES " +
  22.                             "(COF_NAME varchar(32), " +
  23.                             "SUP_ID int, " +
  24.                             "PRICE float, " +
  25.                             "SALES int, " +
  26.                             "TOTAL int)";
  27.         Statement stmt;
  28.     
  29.         try {
  30.             Class.forName("connect.sybase.SybaseDriver");
  31.  
  32.         } catch(java.lang.ClassNotFoundException e) {
  33.             System.err.print("ClassNotFoundException: "); 
  34.             System.err.println(e.getMessage());
  35.         }
  36.  
  37.         try {
  38.             con = DriverManager.getConnection(url, 
  39.                                      "guest", "trustworthy");
  40.     
  41.             stmt = con.createStatement();                            
  42.                    stmt.executeUpdate(createString);
  43.     
  44.             stmt.close();
  45.             con.close();
  46.     
  47.         } catch(SQLException ex) {
  48.             System.err.println("SQLException: " + ex.getMessage());
  49.         }
  50.  
  51.     }
  52. }
  53.  
  54.